CREATE TABLE [dbo].[JY_Ad]
(
[JY_Ad_ID] [int] NOT NULL IDENTITY(1, 1),
[JY_Ad_Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Ad_Path] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Ad_Add_User] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Ad_Add_Time] [datetime] NULL,
[JY_Ad_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Ad_Remark] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Ad_UrlLink] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Ad_Status] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JY_Ad] ADD CONSTRAINT [PK_JY_Ad] PRIMARY KEY CLUSTERED  ([JY_Ad_ID]) ON [PRIMARY]
GO
